The given solution does not cover where the permission is granted against the schema or the database itself, which do grant permissions ... ... <看更多>

GRANT Object Permissions (Transact-SQL) ... Grants permissions on a table, view, table-valued function, stored procedure, extended stored procedure, scalar ... ... <看更多>

... <看更多>

Users other than the owner must be granted EXECUTE permission on a function (if the function is scalar-valued) before they can use it in a Transact-SQL ... ... <看更多>